package com.fw.service.persistence.dao;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import com.fw.service.persistence.dto.MerchantUser;

public interface MerchantUserDAO extends JpaRepository<MerchantUser, Long>, JpaSpecificationExecutor<MerchantUser> {

    @Query("select distinct t.createBy from MerchantUser t order by t.createBy")
    public List<Object> selectDistinctCreateBy();

    @Query("select distinct t.lastUpdateBy from MerchantUser t order by t.lastUpdateBy")
    public List<Object> selectDistinctLastUpdateBy();

    @Query("select distinct t.email from MerchantUser t order by t.email")
    public List<Object> selectDistinctEmail();
}
